Defaults Client Profiling Report

Dataset statistics

Number of variables	25
Number of observations	29459
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	5.6 MiB
Average record size in memory	200.0 B

Variable types

NUM	21
CAT	3
BOOL	1

Reproduction

Analysis started	2020-07-28 08:28:16.033969
Analysis finished	2020-07-28 08:29:41.772545
Duration	1 minute and 25.74 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`bill_amt2` is highly correlated with `bill_amt1` and 2 other fields	High correlation
`bill_amt1` is highly correlated with `bill_amt2` and 1 other fields	High correlation
`bill_amt3` is highly correlated with `bill_amt1` and 3 other fields	High correlation
`bill_amt4` is highly correlated with `bill_amt2` and 3 other fields	High correlation
`bill_amt5` is highly correlated with `bill_amt3` and 2 other fields	High correlation
`bill_amt6` is highly correlated with `bill_amt4` and 1 other fields	High correlation
`df_index` has unique values	Unique
`pay_0` has 14445 (49.0%) zeros	Zeros
`pay_2` has 15422 (52.4%) zeros	Zeros
`pay_3` has 15463 (52.5%) zeros	Zeros
`pay_4` has 16138 (54.8%) zeros	Zeros
`pay_5` has 16596 (56.3%) zeros	Zeros
`pay_6` has 15949 (54.1%) zeros	Zeros
`bill_amt1` has 1986 (6.7%) zeros	Zeros
`bill_amt2` has 2472 (8.4%) zeros	Zeros
`bill_amt3` has 2835 (9.6%) zeros	Zeros
`bill_amt4` has 3160 (10.7%) zeros	Zeros
`bill_amt5` has 3470 (11.8%) zeros	Zeros
`bill_amt6` has 3969 (13.5%) zeros	Zeros
`pay_amt1` has 5169 (17.5%) zeros	Zeros
`pay_amt2` has 5309 (18.0%) zeros	Zeros
`pay_amt3` has 5884 (20.0%) zeros	Zeros
`pay_amt4` has 6324 (21.5%) zeros	Zeros
`pay_amt5` has 6603 (22.4%) zeros	Zeros
`pay_amt6` has 7065 (24.0%) zeros	Zeros

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct count	29459
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	15002.93255032418
Minimum	0
Maximum	29999
Zeros	1
Zeros (%)	< 0.1%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	1506.9
Q1	7513.5
median	15013
Q3	22493.5
95-th percentile	28493.1
Maximum	29999
Range	29999
Interquartile range (IQR)	14980

Descriptive statistics

Standard deviation	8657.215564
Coefficient of variation (CV)	0.577034892
Kurtosis	-1.199756933
Mean	15002.93255
Median Absolute Deviation (MAD)	7491
Skewness	-0.0004932886091
Sum	441971390
Variance	74947381.32

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2047	1	< 0.1%
3307	1	< 0.1%
15597	1	< 0.1%
9454	1	< 0.1%
11503	1	< 0.1%
21760	1	< 0.1%
23809	1	< 0.1%
17666	1	< 0.1%
19715	1	< 0.1%
29956	1	< 0.1%
25862	1	< 0.1%
27911	1	< 0.1%
5384	1	< 0.1%
7433	1	< 0.1%
1290	1	< 0.1%
3339	1	< 0.1%
13580	1	< 0.1%
15629	1	< 0.1%
9486	1	< 0.1%
11535	1	< 0.1%
21792	1	< 0.1%
23841	1	< 0.1%
17698	1	< 0.1%
19747	1	< 0.1%
29988	1	< 0.1%
Other values (29434)	29434	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
29999	1	< 0.1%
29998	1	< 0.1%
29997	1	< 0.1%
29996	1	< 0.1%
29995	1	< 0.1%
29994	1	< 0.1%
29993	1	< 0.1%
29992	1	< 0.1%
29991	1	< 0.1%
29990	1	< 0.1%

limit_bal
Real number (ℝ_≥0)

Distinct count	79
Unique (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	167079.31973250958
Minimum	10000
Maximum	800000
Zeros	0
Zeros (%)	0.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	10000
5-th percentile	20000
Q1	50000
median	140000
Q3	240000
95-th percentile	430000
Maximum	800000
Range	790000
Interquartile range (IQR)	190000

Descriptive statistics

Standard deviation	128780.3336
Coefficient of variation (CV)	0.7707736289
Kurtosis	0.4806109595
Mean	167079.3197
Median Absolute Deviation (MAD)	90000
Skewness	0.9806362923
Sum	4921989680
Variance	1.658437432e+10

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
50000	3287	11.2%
20000	1926	6.5%
30000	1578	5.4%
80000	1545	5.2%
200000	1508	5.1%
150000	1096	3.7%
100000	1038	3.5%
180000	986	3.3%
360000	868	2.9%
60000	807	2.7%
140000	741	2.5%
230000	733	2.5%
210000	725	2.5%
130000	721	2.4%
120000	716	2.4%
70000	714	2.4%
500000	692	2.3%
160000	690	2.3%
90000	640	2.2%
240000	608	2.1%
110000	579	2.0%
300000	546	1.9%
170000	527	1.8%
260000	514	1.7%
280000	486	1.6%
Other values (54)	5188	17.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10000	479	1.6%
16000	2	< 0.1%
20000	1926	6.5%
30000	1578	5.4%
40000	227	0.8%
50000	3287	11.2%
60000	807	2.7%
70000	714	2.4%
80000	1545	5.2%
90000	640	2.2%

Value	Count	Frequency (%)
800000	2	< 0.1%
780000	2	< 0.1%
760000	1	< 0.1%
750000	3	< 0.1%
740000	2	< 0.1%
720000	3	< 0.1%
710000	6	< 0.1%
700000	8	< 0.1%
690000	1	< 0.1%
680000	3	< 0.1%

sex
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	230.3 KiB

2	17796
1	11663

Value	Count	Frequency (%)
2	17796	60.4%
1	11663	39.6%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	2
Unique unicode categories (?)	1
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
2	17796	60.4%
1	11663	39.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	29459	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
2	17796	60.4%
1	11663	39.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	29459	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
2	17796	60.4%
1	11663	39.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29459	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
2	17796	60.4%
1	11663	39.6%

education
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	230.3 KiB

2	13791
1	10459
3	4752
4	457

Value	Count	Frequency (%)
2	13791	46.8%
1	10459	35.5%
3	4752	16.1%
4	457	1.6%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	4
Unique unicode categories (?)	1
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
2	13791	46.8%
1	10459	35.5%
3	4752	16.1%
4	457	1.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	29459	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
2	13791	46.8%
1	10459	35.5%
3	4752	16.1%
4	457	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	29459	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
2	13791	46.8%
1	10459	35.5%
3	4752	16.1%
4	457	1.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29459	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
2	13791	46.8%
1	10459	35.5%
3	4752	16.1%
4	457	1.6%

marriage
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	230.3 KiB

2	15878
1	13581

Value	Count	Frequency (%)
2	15878	53.9%
1	13581	46.1%

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Overview of Unicode Properties

Unique unicode characters	2
Unique unicode categories (?)	1
Unique unicode scripts (?)	1
Unique unicode blocks (?)	1

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Most occurring characters

Value	Count	Frequency (%)
2	15878	53.9%
1	13581	46.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	29459	100.0%

Most frequent Decimal Number characters

Value	Count	Frequency (%)
2	15878	53.9%
1	13581	46.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	29459	100.0%

Most frequent Common characters

Value	Count	Frequency (%)
2	15878	53.9%
1	13581	46.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	29459	100.0%

Most frequent ASCII characters

Value	Count	Frequency (%)
2	15878	53.9%
1	13581	46.1%

age
Real number (ℝ_≥0)

Distinct count	56
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	35.39030516989715
Minimum	21
Maximum	79
Zeros	0
Zeros (%)	0.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	21
5-th percentile	23
Q1	28
median	34
Q3	41
95-th percentile	53
Maximum	79
Range	58
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	9.184883452
Coefficient of variation (CV)	0.2595310611
Kurtosis	0.07959641048
Mean	35.39030517
Median Absolute Deviation (MAD)	6
Skewness	0.7450257384
Sum	1042563
Variance	84.36208402

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
29	1590	5.4%
27	1462	5.0%
28	1393	4.7%
30	1371	4.7%
26	1247	4.2%
31	1203	4.1%
25	1181	4.0%
34	1147	3.9%
32	1144	3.9%
33	1129	3.8%
24	1120	3.8%
36	1096	3.7%
35	1096	3.7%
37	1012	3.4%
39	936	3.2%
38	934	3.2%
23	928	3.2%
40	848	2.9%
41	804	2.7%
42	776	2.6%
44	681	2.3%
43	652	2.2%
45	595	2.0%
22	554	1.9%
46	552	1.9%
Other values (31)	4008	13.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
21	67	0.2%
22	554	1.9%
23	928	3.2%
24	1120	3.8%
25	1181	4.0%
26	1247	4.2%
27	1462	5.0%
28	1393	4.7%
29	1590	5.4%
30	1371	4.7%

Value	Count	Frequency (%)
79	1	< 0.1%
75	3	< 0.1%
74	1	< 0.1%
73	4	< 0.1%
72	3	< 0.1%
71	3	< 0.1%
70	10	< 0.1%
69	15	0.1%
68	5	< 0.1%
67	16	0.1%

pay_0
Real number (ℝ)

ZEROS

Distinct count	11
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.01738008757934757
Minimum	-2
Maximum	8
Zeros	14445
Zeros (%)	49.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	8
Range	10
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.124582306
Coefficient of variation (CV)	-64.70521512
Kurtosis	2.732851872
Mean	-0.01738008758
Median Absolute Deviation (MAD)	1
Skewness	0.7333496664
Sum	-512
Variance	1.264685362

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	14445	49.0%
-1	5599	19.0%
1	3622	12.3%
-2	2715	9.2%
2	2626	8.9%
3	314	1.1%
4	75	0.3%
5	24	0.1%
8	19	0.1%
6	11	< 0.1%
7	9	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	2715	9.2%
-1	5599	19.0%
0	14445	49.0%
1	3622	12.3%
2	2626	8.9%
3	314	1.1%
4	75	0.3%
5	24	0.1%
6	11	< 0.1%
7	9	< 0.1%

Value	Count	Frequency (%)
8	19	0.1%
7	9	< 0.1%
6	11	< 0.1%
5	24	0.1%
4	75	0.3%
3	314	1.1%
2	2626	8.9%
1	3622	12.3%
0	14445	49.0%
-1	5599	19.0%

pay_2
Real number (ℝ)

ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.1342543874537493
Minimum	-2
Maximum	7
Zeros	15422
Zeros (%)	52.4%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.197458438
Coefficient of variation (CV)	-8.919324432
Kurtosis	1.508418312
Mean	-0.1342543875
Median Absolute Deviation (MAD)	0
Skewness	0.7814386906
Sum	-3955
Variance	1.433906711

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	15422	52.4%
-1	5945	20.2%
2	3870	13.1%
-2	3725	12.6%
3	321	1.1%
4	95	0.3%
1	25	0.1%
5	24	0.1%
7	20	0.1%
6	12	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	3725	12.6%
-1	5945	20.2%
0	15422	52.4%
1	25	0.1%
2	3870	13.1%
3	321	1.1%
4	95	0.3%
5	24	0.1%
6	12	< 0.1%
7	20	0.1%

Value	Count	Frequency (%)
7	20	0.1%
6	12	< 0.1%
5	24	0.1%
4	95	0.3%
3	321	1.1%
2	3870	13.1%
1	25	0.1%
0	15422	52.4%
-1	5945	20.2%
-2	3725	12.6%

pay_3
Real number (ℝ)

ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.16853932584269662
Minimum	-2
Maximum	7
Zeros	15463
Zeros (%)	52.5%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.193314857
Coefficient of variation (CV)	-7.080334818
Kurtosis	1.830949329
Mean	-0.1685393258
Median Absolute Deviation (MAD)	0
Skewness	0.8025290059
Sum	-4965
Variance	1.424000348

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	15463	52.5%
-1	5831	19.8%
-2	4029	13.7%
2	3758	12.8%
3	234	0.8%
4	73	0.2%
7	24	0.1%
6	23	0.1%
5	21	0.1%
1	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	4029	13.7%
-1	5831	19.8%
0	15463	52.5%
1	3	< 0.1%
2	3758	12.8%
3	234	0.8%
4	73	0.2%
5	21	0.1%
6	23	0.1%
7	24	0.1%

Value	Count	Frequency (%)
7	24	0.1%
6	23	0.1%
5	21	0.1%
4	73	0.2%
3	234	0.8%
2	3758	12.8%
1	3	< 0.1%
0	15463	52.5%
-1	5831	19.8%
-2	4029	13.7%

pay_4
Real number (ℝ)

ZEROS

Distinct count	10
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.2227163175939441
Minimum	-2
Maximum	7
Zeros	16138
Zeros (%)	54.8%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.165999383
Coefficient of variation (CV)	-5.235356777
Kurtosis	3.23097029
Mean	-0.2227163176
Median Absolute Deviation (MAD)	0
Skewness	0.9587710912
Sum	-6561
Variance	1.35955456

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16138	54.8%
-1	5578	18.9%
-2	4292	14.6%
2	3114	10.6%
3	175	0.6%
4	69	0.2%
7	54	0.2%
5	35	0.1%
6	3	< 0.1%
1	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	4292	14.6%
-1	5578	18.9%
0	16138	54.8%
1	1	< 0.1%
2	3114	10.6%
3	175	0.6%
4	69	0.2%
5	35	0.1%
6	3	< 0.1%
7	54	0.2%

Value	Count	Frequency (%)
7	54	0.2%
6	3	< 0.1%
5	35	0.1%
4	69	0.2%
3	175	0.6%
2	3114	10.6%
1	1	< 0.1%
0	16138	54.8%
-1	5578	18.9%
-2	4292	14.6%

pay_5
Real number (ℝ)

ZEROS

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.2685766658746054
Minimum	-2
Maximum	7
Zeros	16596
Zeros (%)	56.3%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.131412577
Coefficient of variation (CV)	-4.212624256
Kurtosis	3.705392297
Mean	-0.2685766659
Median Absolute Deviation (MAD)	0
Skewness	0.9669595996
Sum	-7912
Variance	1.28009442

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	16596	56.3%
-1	5441	18.5%
-2	4496	15.3%
2	2594	8.8%
3	176	0.6%
4	84	0.3%
7	53	0.2%
5	16	0.1%
6	3	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	4496	15.3%
-1	5441	18.5%
0	16596	56.3%
2	2594	8.8%
3	176	0.6%
4	84	0.3%
5	16	0.1%
6	3	< 0.1%
7	53	0.2%

Value	Count	Frequency (%)
7	53	0.2%
6	3	< 0.1%
5	16	0.1%
4	84	0.3%
3	176	0.6%
2	2594	8.8%
0	16596	56.3%
-1	5441	18.5%
-2	4496	15.3%

pay_6
Real number (ℝ)

ZEROS

Distinct count	9
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	-0.2940357785396653
Minimum	-2
Maximum	7
Zeros	15949
Zeros (%)	54.1%
Memory size	230.3 KiB

Quantile statistics

Minimum	-2
5-th percentile	-2
Q1	-1
median	0
Q3	0
95-th percentile	2
Maximum	7
Range	9
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.148624443
Coefficient of variation (CV)	-3.906410468
Kurtosis	3.194076657
Mean	-0.2940357785
Median Absolute Deviation (MAD)	0
Skewness	0.9137449283
Sum	-8662
Variance	1.319338111

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	15949	54.1%
-1	5632	19.1%
-2	4847	16.5%
2	2728	9.3%
3	183	0.6%
4	47	0.2%
7	45	0.2%
6	16	0.1%
5	12	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2	4847	16.5%
-1	5632	19.1%
0	15949	54.1%
2	2728	9.3%
3	183	0.6%
4	47	0.2%
5	12	< 0.1%
6	16	0.1%
7	45	0.2%

Value	Count	Frequency (%)
7	45	0.2%
6	16	0.1%
5	12	< 0.1%
4	47	0.2%
3	183	0.6%
2	2728	9.3%
0	15949	54.1%
-1	5632	19.1%
-2	4847	16.5%

bill_amt1
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	22341
Unique (%)	75.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50590.48840761737
Minimum	-154973
Maximum	613860
Zeros	1986
Zeros (%)	6.7%
Memory size	230.3 KiB

Quantile statistics

Minimum	-154973
5-th percentile	0
Q1	3489.5
median	22241
Q3	66841.5
95-th percentile	198667.1
Maximum	613860
Range	768833
Interquartile range (IQR)	63352

Descriptive statistics

Standard deviation	71711.63921
Coefficient of variation (CV)	1.417492526
Kurtosis	8.146381789
Mean	50590.48841
Median Absolute Deviation (MAD)	21674
Skewness	2.515873724
Sum	1490345198
Variance	5142559198

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	1986	6.7%
390	239	0.8%
780	72	0.2%
326	70	0.2%
316	62	0.2%
2500	59	0.2%
396	49	0.2%
2400	36	0.1%
416	29	0.1%
500	25	0.1%
1050	25	0.1%
1473	24	0.1%
1261	22	0.1%
-200	22	0.1%
-5	21	0.1%
836	20	0.1%
264	20	0.1%
-3	19	0.1%
291	18	0.1%
600	17	0.1%
-2	17	0.1%
360	17	0.1%
-1	16	0.1%
-4	16	0.1%
1000	16	0.1%
Other values (22316)	26542	90.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-154973	1	< 0.1%
-15308	1	< 0.1%
-14386	1	< 0.1%
-11545	1	< 0.1%
-10682	1	< 0.1%
-9802	1	< 0.1%
-9095	1	< 0.1%
-8187	1	< 0.1%
-7438	1	< 0.1%
-7082	1	< 0.1%

Value	Count	Frequency (%)
613860	1	< 0.1%
604019	1	< 0.1%
588000	1	< 0.1%
581319	1	< 0.1%
564757	1	< 0.1%
562326	1	< 0.1%
546741	1	< 0.1%
546485	1	< 0.1%
542827	1	< 0.1%
533142	1	< 0.1%

bill_amt2
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	21978
Unique (%)	74.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	48617.644862351066
Minimum	-69777
Maximum	605943
Zeros	2472
Zeros (%)	8.4%
Memory size	230.3 KiB

Quantile statistics

Minimum	-69777
5-th percentile	0
Q1	2947.5
median	21092
Q3	63739.5
95-th percentile	192512.1
Maximum	605943
Range	675720
Interquartile range (IQR)	60792

Descriptive statistics

Standard deviation	69346.89231
Coefficient of variation (CV)	1.426372925
Kurtosis	8.30586925
Mean	48617.64486
Median Absolute Deviation (MAD)	20702
Skewness	2.536596574
Sum	1432227200
Variance	4808991473

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2472	8.4%
390	226	0.8%
326	74	0.3%
780	72	0.2%
316	71	0.2%
2500	51	0.2%
396	51	0.2%
2400	39	0.1%
-200	29	0.1%
416	28	0.1%
1050	25	0.1%
1261	24	0.1%
1473	23	0.1%
1000	22	0.1%
264	22	0.1%
291	22	0.1%
-3	21	0.1%
-2	21	0.1%
150	20	0.1%
-1	18	0.1%
-18	18	0.1%
-5	18	0.1%
200	18	0.1%
300	17	0.1%
-4	16	0.1%
Other values (21953)	26041	88.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-69777	1	< 0.1%
-67526	1	< 0.1%
-33350	1	< 0.1%
-30000	1	< 0.1%
-26214	1	< 0.1%
-24704	1	< 0.1%
-24702	1	< 0.1%
-18618	1	< 0.1%
-17810	1	< 0.1%
-15910	1	< 0.1%

Value	Count	Frequency (%)
605943	1	< 0.1%
572834	1	< 0.1%
552144	1	< 0.1%
539418	1	< 0.1%
535509	1	< 0.1%
534289	1	< 0.1%
532374	1	< 0.1%
524555	1	< 0.1%
522309	1	< 0.1%
520643	1	< 0.1%

bill_amt3
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	21668
Unique (%)	73.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46322.599579076006
Minimum	-61506
Maximum	548020
Zeros	2835
Zeros (%)	9.6%
Memory size	230.3 KiB

Quantile statistics

Minimum	-61506
5-th percentile	0
Q1	2626.5
median	20035
Q3	59892
95-th percentile	184973.3
Maximum	548020
Range	609526
Interquartile range (IQR)	57265.5

Descriptive statistics

Standard deviation	66602.15627
Coefficient of variation (CV)	1.437789694
Kurtosis	8.474450882
Mean	46322.59958
Median Absolute Deviation (MAD)	19655
Skewness	2.563058617
Sum	1364617461
Variance	4435847219

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2835	9.6%
390	268	0.9%
780	72	0.2%
316	62	0.2%
326	61	0.2%
396	47	0.2%
2500	40	0.1%
2400	36	0.1%
416	29	0.1%
200	27	0.1%
1000	25	0.1%
264	23	0.1%
-200	23	0.1%
-1	23	0.1%
500	23	0.1%
291	23	0.1%
1050	22	0.1%
-2	22	0.1%
150	20	0.1%
-18	19	0.1%
-3	19	0.1%
1261	18	0.1%
380	17	0.1%
10000	17	0.1%
1170	16	0.1%
Other values (21643)	25672	87.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-61506	1	< 0.1%
-46127	1	< 0.1%
-34041	1	< 0.1%
-25443	1	< 0.1%
-24702	1	< 0.1%
-20320	1	< 0.1%
-15910	1	< 0.1%
-15641	1	< 0.1%
-15000	1	< 0.1%
-14998	1	< 0.1%

Value	Count	Frequency (%)
548020	1	< 0.1%
537543	1	< 0.1%
534137	1	< 0.1%
523423	1	< 0.1%
520492	1	< 0.1%
519267	1	< 0.1%
517746	1	< 0.1%
499936	1	< 0.1%
498839	1	< 0.1%
498646	1	< 0.1%

bill_amt4
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	21181
Unique (%)	71.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	42509.289079737944
Minimum	-65167
Maximum	542653
Zeros	3160
Zeros (%)	10.7%
Memory size	230.3 KiB

Quantile statistics

Minimum	-65167
5-th percentile	0
Q1	2296
median	19000
Q3	54060.5
95-th percentile	170693.5
Maximum	542653
Range	607820
Interquartile range (IQR)	51764.5

Descriptive statistics

Standard deviation	62052.36241
Coefficient of variation (CV)	1.459736536
Kurtosis	9.267970891
Mean	42509.28908
Median Absolute Deviation (MAD)	18604
Skewness	2.647260391
Sum	1252281147
Variance	3850495680

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3160	10.7%
390	242	0.8%
780	97	0.3%
316	68	0.2%
326	61	0.2%
396	44	0.1%
150	38	0.1%
2400	36	0.1%
2500	34	0.1%
416	33	0.1%
1000	32	0.1%
-3	27	0.1%
-1	24	0.1%
-18	24	0.1%
1050	24	0.1%
1261	24	0.1%
-2	23	0.1%
300	22	0.1%
291	21	0.1%
600	20	0.1%
264	17	0.1%
380	16	0.1%
632	16	0.1%
1170	16	0.1%
-10	16	0.1%
Other values (21156)	25324	86.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-65167	1	< 0.1%
-50616	1	< 0.1%
-46627	1	< 0.1%
-34503	1	< 0.1%
-27490	1	< 0.1%
-24303	1	< 0.1%
-22108	1	< 0.1%
-20320	1	< 0.1%
-17250	1	< 0.1%
-15910	1	< 0.1%

Value	Count	Frequency (%)
542653	1	< 0.1%
541019	1	< 0.1%
530672	1	< 0.1%
525749	1	< 0.1%
518741	1	< 0.1%
505507	1	< 0.1%
504929	1	< 0.1%
496400	1	< 0.1%
493548	1	< 0.1%
489978	1	< 0.1%

bill_amt5
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	20657
Unique (%)	70.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	39567.07165891578
Minimum	-61372
Maximum	516139
Zeros	3470
Zeros (%)	11.8%
Memory size	230.3 KiB

Quantile statistics

Minimum	-61372
5-th percentile	0
Q1	1740
median	18037
Q3	49985
95-th percentile	162132.4
Maximum	516139
Range	577511
Interquartile range (IQR)	48245

Descriptive statistics

Standard deviation	58554.19347
Coefficient of variation (CV)	1.479871798
Kurtosis	9.458562009
Mean	39567.07166
Median Absolute Deviation (MAD)	17623
Skewness	2.664496252
Sum	1165606364
Variance	3428593573

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3470	11.8%
390	230	0.8%
780	92	0.3%
316	79	0.3%
326	59	0.2%
150	58	0.2%
396	47	0.2%
2400	36	0.1%
416	36	0.1%
2500	35	0.1%
-18	32	0.1%
1000	30	0.1%
300	25	0.1%
-1	23	0.1%
1050	23	0.1%
10000	22	0.1%
1473	22	0.1%
600	21	0.1%
1261	19	0.1%
291	19	0.1%
540	18	0.1%
-3	18	0.1%
500	18	0.1%
20000	17	0.1%
-200	17	0.1%
Other values (20632)	24993	84.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-61372	1	< 0.1%
-53007	1	< 0.1%
-46627	1	< 0.1%
-37594	1	< 0.1%
-30481	1	< 0.1%
-28335	1	< 0.1%
-23003	1	< 0.1%
-20753	1	< 0.1%
-20320	1	< 0.1%
-20254	1	< 0.1%

Value	Count	Frequency (%)
516139	1	< 0.1%
505473	1	< 0.1%
503914	1	< 0.1%
501474	1	< 0.1%
500723	1	< 0.1%
493062	1	< 0.1%
489200	1	< 0.1%
486721	1	< 0.1%
484993	1	< 0.1%
484612	1	< 0.1%

bill_amt6
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	20252
Unique (%)	68.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	38171.25269017957
Minimum	-150953
Maximum	527711
Zeros	3969
Zeros (%)	13.5%
Memory size	230.3 KiB

Quantile statistics

Minimum	-150953
5-th percentile	0
Q1	1239.5
median	16944
Q3	48951
95-th percentile	157644.6
Maximum	527711
Range	678664
Interquartile range (IQR)	47711.5

Descriptive statistics

Standard deviation	57439.09415
Coefficient of variation (CV)	1.504773622
Kurtosis	9.666381652
Mean	38171.25269
Median Absolute Deviation (MAD)	16628
Skewness	2.679392755
Sum	1124486933
Variance	3299249537

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	3969	13.5%
390	201	0.7%
780	84	0.3%
316	77	0.3%
150	75	0.3%
326	54	0.2%
396	45	0.2%
416	36	0.1%
-18	33	0.1%
2400	30	0.1%
2500	30	0.1%
500	29	0.1%
540	29	0.1%
1000	29	0.1%
300	26	0.1%
10000	26	0.1%
930	24	0.1%
1050	23	0.1%
-2	23	0.1%
-1	22	0.1%
291	20	0.1%
-200	20	0.1%
1650	18	0.1%
1320	17	0.1%
600	17	0.1%
Other values (20227)	24502	83.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-150953	1	< 0.1%
-94625	1	< 0.1%
-73895	1	< 0.1%
-57060	1	< 0.1%
-51443	1	< 0.1%
-51183	1	< 0.1%
-46627	1	< 0.1%
-45734	1	< 0.1%
-39046	1	< 0.1%
-30895	1	< 0.1%

Value	Count	Frequency (%)
527711	1	< 0.1%
527566	1	< 0.1%
514975	1	< 0.1%
511905	1	< 0.1%
498316	1	< 0.1%
496915	1	< 0.1%
489200	1	< 0.1%
480598	1	< 0.1%
478034	1	< 0.1%
474459	1	< 0.1%

pay_amt1
Real number (ℝ_≥0)

ZEROS

Distinct count	7801
Unique (%)	26.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5466.546793849078
Minimum	0
Maximum	302000
Zeros	5169
Zeros (%)	17.5%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	999.5
median	2100
Q3	5002
95-th percentile	18000
Maximum	302000
Range	302000
Interquartile range (IQR)	4002.5

Descriptive statistics

Standard deviation	14218.1229
Coefficient of variation (CV)	2.600933174
Kurtosis	122.0760149
Mean	5466.546794
Median Absolute Deviation (MAD)	1929
Skewness	9.380222078
Sum	161039002
Variance	202155018.8

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5169	17.5%
2000	1341	4.6%
3000	880	3.0%
5000	693	2.4%
1500	496	1.7%
4000	421	1.4%
10000	392	1.3%
1000	352	1.2%
2500	295	1.0%
6000	290	1.0%
390	202	0.7%
7000	195	0.7%
3500	184	0.6%
1300	181	0.6%
8000	171	0.6%
1600	170	0.6%
1800	161	0.5%
1700	155	0.5%
1200	131	0.4%
2100	128	0.4%
4500	106	0.4%
2200	106	0.4%
15000	94	0.3%
1400	93	0.3%
3200	84	0.3%
Other values (7776)	16969	57.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5169	17.5%
1	9	< 0.1%
2	14	< 0.1%
3	15	0.1%
4	17	0.1%
5	11	< 0.1%
6	15	0.1%
7	9	< 0.1%
8	8	< 0.1%
9	7	< 0.1%

Value	Count	Frequency (%)
302000	1	< 0.1%
300039	1	< 0.1%
298887	1	< 0.1%
276698	1	< 0.1%
273844	1	< 0.1%
272817	1	< 0.1%
261524	1	< 0.1%
260416	1	< 0.1%
260000	1	< 0.1%
247562	1	< 0.1%

pay_amt2
Real number (ℝ_≥0)

ZEROS

Distinct count	7780
Unique (%)	26.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5526.86520248481
Minimum	0
Maximum	312723
Zeros	5309
Zeros (%)	18.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	827
median	2008
Q3	5000
95-th percentile	18516.2
Maximum	312723
Range	312723
Interquartile range (IQR)	4173

Descriptive statistics

Standard deviation	15196.49566
Coefficient of variation (CV)	2.749568716
Kurtosis	116.8410004
Mean	5526.865202
Median Absolute Deviation (MAD)	1992
Skewness	9.283326882
Sum	162815922
Variance	230933480.3

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5309	18.0%
2000	1272	4.3%
3000	847	2.9%
5000	710	2.4%
1000	581	2.0%
1500	506	1.7%
4000	405	1.4%
10000	314	1.1%
6000	280	1.0%
2500	245	0.8%
390	229	0.8%
1200	200	0.7%
1600	181	0.6%
1300	169	0.6%
7000	168	0.6%
3500	166	0.6%
8000	143	0.5%
1400	140	0.5%
1800	135	0.5%
1700	134	0.5%
2200	116	0.4%
2100	108	0.4%
4500	98	0.3%
20000	79	0.3%
9000	76	0.3%
Other values (7755)	16848	57.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5309	18.0%
1	15	0.1%
2	20	0.1%
3	18	0.1%
4	11	< 0.1%
5	24	0.1%
6	8	< 0.1%
7	12	< 0.1%
8	9	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
312723	1	< 0.1%
302961	1	< 0.1%
302000	1	< 0.1%
300018	1	< 0.1%
300000	1	< 0.1%
294318	1	< 0.1%
279048	1	< 0.1%
278505	1	< 0.1%
277510	1	< 0.1%
274526	1	< 0.1%

pay_amt3
Real number (ℝ_≥0)

ZEROS

Distinct count	7368
Unique (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4727.996062323908
Minimum	0
Maximum	174749
Zeros	5884
Zeros (%)	20.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	390
median	1800
Q3	4500
95-th percentile	16683.5
Maximum	174749
Range	174749
Interquartile range (IQR)	4110

Descriptive statistics

Standard deviation	11847.61376
Coefficient of variation (CV)	2.505842561
Kurtosis	67.09497284
Mean	4727.996062
Median Absolute Deviation (MAD)	1794
Skewness	7.242447034
Sum	139282036
Variance	140365951.8

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5884	20.0%
2000	1268	4.3%
1000	1079	3.7%
3000	863	2.9%
5000	714	2.4%
1500	479	1.6%
4000	378	1.3%
10000	308	1.0%
1200	238	0.8%
6000	236	0.8%
2500	225	0.8%
390	205	0.7%
1300	158	0.5%
500	152	0.5%
7000	152	0.5%
8000	142	0.5%
3500	140	0.5%
1600	131	0.4%
1400	120	0.4%
1800	119	0.4%
1700	102	0.3%
20000	83	0.3%
1100	83	0.3%
4500	83	0.3%
15000	79	0.3%
Other values (7343)	16038	54.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5884	20.0%
1	12	< 0.1%
2	19	0.1%
3	14	< 0.1%
4	15	0.1%
5	18	0.1%
6	14	< 0.1%
7	18	0.1%
8	9	< 0.1%
9	11	< 0.1%

Value	Count	Frequency (%)
174749	1	< 0.1%
174169	1	< 0.1%
169267	1	< 0.1%
166853	1	< 0.1%
163862	1	< 0.1%
163597	1	< 0.1%
162546	1	< 0.1%
162434	1	< 0.1%
160944	1	< 0.1%
160578	1	< 0.1%

pay_amt4
Real number (ℝ_≥0)

ZEROS

Distinct count	6812
Unique (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4525.890457924573
Minimum	0
Maximum	211250
Zeros	6324
Zeros (%)	21.5%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	291
median	1500
Q3	4000
95-th percentile	15653.2
Maximum	211250
Range	211250
Interquartile range (IQR)	3709

Descriptive statistics

Standard deviation	12386.75176
Coefficient of variation (CV)	2.736865126
Kurtosis	82.87101708
Mean	4525.890458
Median Absolute Deviation (MAD)	1500
Skewness	7.938938306
Sum	133328207
Variance	153431619.1

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	6324	21.5%
1000	1360	4.6%
2000	1199	4.1%
3000	881	3.0%
5000	800	2.7%
1500	436	1.5%
4000	400	1.4%
10000	334	1.1%
2500	254	0.9%
6000	250	0.8%
500	248	0.8%
390	205	0.7%
1200	169	0.6%
3500	167	0.6%
7000	160	0.5%
1100	139	0.5%
700	137	0.5%
600	120	0.4%
8000	117	0.4%
800	90	0.3%
1300	85	0.3%
20000	85	0.3%
1600	84	0.3%
1800	80	0.3%
4500	77	0.3%
Other values (6787)	15258	51.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6324	21.5%
1	21	0.1%
2	22	0.1%
3	13	< 0.1%
4	20	0.1%
5	12	< 0.1%
6	16	0.1%
7	11	< 0.1%
8	7	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
211250	1	< 0.1%
208821	1	< 0.1%
205000	1	< 0.1%
202076	1	< 0.1%
200128	1	< 0.1%
200000	1	< 0.1%
194989	1	< 0.1%
193712	1	< 0.1%
192994	1	< 0.1%
190071	1	< 0.1%

pay_amt5
Real number (ℝ_≥0)

ZEROS

Distinct count	6778
Unique (%)	23.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4520.030143589395
Minimum	0
Maximum	208122
Zeros	6603
Zeros (%)	22.4%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	246.5
median	1500
Q3	4003
95-th percentile	15396.2
Maximum	208122
Range	208122
Interquartile range (IQR)	3756.5

Descriptive statistics

Standard deviation	12525.53963
Coefficient of variation (CV)	2.771118607
Kurtosis	87.87586793
Mean	4520.030144
Median Absolute Deviation (MAD)	1500
Skewness	8.191554741
Sum	133155568
Variance	156889143.1

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	6603	22.4%
1000	1306	4.4%
2000	1305	4.4%
3000	937	3.2%
5000	808	2.7%
1500	416	1.4%
4000	399	1.4%
10000	337	1.1%
500	246	0.8%
6000	243	0.8%
2500	229	0.8%
390	173	0.6%
1200	159	0.5%
7000	157	0.5%
3500	157	0.5%
1100	125	0.4%
8000	116	0.4%
700	115	0.4%
600	113	0.4%
1600	100	0.3%
20000	90	0.3%
1300	89	0.3%
4500	87	0.3%
1800	87	0.3%
800	81	0.3%
Other values (6753)	14981	50.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	6603	22.4%
1	21	0.1%
2	13	< 0.1%
3	13	< 0.1%
4	11	< 0.1%
5	8	< 0.1%
6	7	< 0.1%
7	9	< 0.1%
8	6	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
208122	1	< 0.1%
207440	1	< 0.1%
207019	1	< 0.1%
205430	1	< 0.1%
205000	1	< 0.1%
202317	1	< 0.1%
200000	1	< 0.1%
195829	1	< 0.1%
195599	1	< 0.1%
194541	1	< 0.1%

pay_amt6
Real number (ℝ_≥0)

ZEROS

Distinct count	6813
Unique (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4851.510540072643
Minimum	0
Maximum	211192
Zeros	7065
Zeros (%)	24.0%
Memory size	230.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	107
median	1500
Q3	4000
95-th percentile	16951.1
Maximum	211192
Range	211192
Interquartile range (IQR)	3893

Descriptive statistics

Standard deviation	14468.86445
Coefficient of variation (CV)	2.982342165
Kurtosis	77.5713468
Mean	4851.51054
Median Absolute Deviation (MAD)	1500
Skewness	7.90083514
Sum	142920649
Variance	209348038.5

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	7065	24.0%
2000	1274	4.3%
1000	1268	4.3%
3000	907	3.1%
5000	800	2.7%
1500	435	1.5%
4000	405	1.4%
10000	350	1.2%
500	242	0.8%
6000	218	0.7%
2500	211	0.7%
390	170	0.6%
3500	159	0.5%
7000	146	0.5%
1200	144	0.5%
8000	114	0.4%
600	110	0.4%
1100	107	0.4%
4500	99	0.3%
1600	97	0.3%
700	97	0.3%
800	95	0.3%
780	91	0.3%
1300	80	0.3%
1700	80	0.3%
Other values (6788)	14695	49.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	7065	24.0%
1	20	0.1%
2	9	< 0.1%
3	14	< 0.1%
4	12	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	5	< 0.1%
8	6	< 0.1%
9	7	< 0.1%

Value	Count	Frequency (%)
211192	1	< 0.1%
210759	1	< 0.1%
210000	1	< 0.1%
208896	1	< 0.1%
204395	1	< 0.1%
204297	1	< 0.1%
201323	1	< 0.1%
201277	1	< 0.1%
201134	1	< 0.1%
200655	1	< 0.1%

defaulted
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	230.3 KiB

0	22940
1	6519

Frequency Table

Value	Count	Frequency (%)
0	22940	77.9%
1	6519	22.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

First rows

	df_index	limit_bal	sex	education	marriage	age	pay_0	pay_2	pay_3	pay_4	pay_5	pay_6	bill_amt1	bill_amt2	bill_amt3	bill_amt4	bill_amt5	bill_amt6	pay_amt1	pay_amt2	pay_amt3	pay_amt4	pay_amt5	pay_amt6	defaulted
0	0	20000	2	2	1	24	2	2	-1	-1	-2	-2	3913	3102	689	0	0	0	0	689	0	0	0	0	1
1	1	120000	2	2	2	26	-1	2	0	0	0	2	2682	1725	2682	3272	3455	3261	0	1000	1000	1000	0	2000	1
2	2	90000	2	2	2	34	0	0	0	0	0	0	29239	14027	13559	14331	14948	15549	1518	1500	1000	1000	1000	5000	0
3	3	50000	2	2	1	37	0	0	0	0	0	0	46990	48233	49291	28314	28959	29547	2000	2019	1200	1100	1069	1000	0
4	4	50000	1	2	1	57	-1	0	-1	0	0	0	8617	5670	35835	20940	19146	19131	2000	36681	10000	9000	689	679	0
5	5	50000	1	1	2	37	0	0	0	0	0	0	64400	57069	57608	19394	19619	20024	2500	1815	657	1000	1000	800	0
6	6	500000	1	1	2	29	0	0	0	0	0	0	367965	412023	445007	542653	483003	473944	55000	40000	38000	20239	13750	13770	0
7	7	100000	2	2	2	23	0	-1	-1	0	0	-1	11876	380	601	221	-159	567	380	601	0	581	1687	1542	0
8	8	140000	2	3	1	28	0	0	2	0	0	0	11285	14096	12108	12211	11793	3719	3329	0	432	1000	1000	1000	0
9	9	20000	1	3	2	35	-2	-2	-2	-2	-1	-1	0	0	0	0	13007	13912	0	0	0	13007	1122	0	0

Last rows

	df_index	limit_bal	sex	education	marriage	age	pay_0	pay_2	pay_3	pay_4	pay_5	pay_6	bill_amt1	bill_amt2	bill_amt3	bill_amt4	bill_amt5	bill_amt6	pay_amt1	pay_amt2	pay_amt3	pay_amt4	pay_amt5	pay_amt6	defaulted
29449	29990	140000	1	2	1	41	0	0	0	0	0	0	138325	137142	139110	138262	49675	46121	6000	7000	4228	1505	2000	2000	0
29450	29991	210000	1	2	1	34	3	2	2	2	2	2	2500	2500	2500	2500	2500	2500	0	0	0	0	0	0	1
29451	29992	10000	1	3	1	43	0	0	0	-2	-2	-2	8802	10400	0	0	0	0	2000	0	0	0	0	0	0
29452	29993	100000	1	1	2	38	0	-1	-1	0	0	0	3042	1427	102996	70626	69473	55004	2000	111784	4000	3000	2000	2000	0
29453	29994	80000	1	2	2	34	2	2	2	2	2	2	72557	77708	79384	77519	82607	81158	7000	3500	0	7000	0	4000	1
29454	29995	220000	1	3	1	39	0	0	0	0	0	0	188948	192815	208365	88004	31237	15980	8500	20000	5003	3047	5000	1000	0
29455	29996	150000	1	3	2	43	-1	-1	-1	-1	0	0	1683	1828	3502	8979	5190	0	1837	3526	8998	129	0	0	0
29456	29997	30000	1	2	2	37	4	3	2	-1	0	0	3565	3356	2758	20878	20582	19357	0	0	22000	4200	2000	3100	1
29457	29998	80000	1	3	1	41	1	-1	0	0	0	-1	-1645	78379	76304	52774	11855	48944	85900	3409	1178	1926	52964	1804	1
29458	29999	50000	1	2	1	46	0	0	0	0	0	0	47929	48905	49764	36535	32428	15313	2078	1800	1430	1000	1000	1000	1

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Most occurring characters

Most occurring categories

Most frequent Decimal Number characters

Most occurring scripts

Most frequent Common characters

Most occurring blocks

Most frequent ASCII characters

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows